IF exists(SELECT * FROM dbo.sysobjects WHERE name='leerlingenMetTit' AND xtype='V') 
BEGIN
	DROP VIEW leerlingenMetTit
END
GO

CREATE view leerlingenMetTit as
select l.*,t.voornaam+' '+t.achternaam as volleNaam from leerlingen as l
left join leraars..titularisKlas as t
on t.klas=l.klas